You are here: Reports > BI Reporting > Scheduling BI Reporting Reports

Scheduling BI Reporting Reports

You can schedule reports to automatically generate at some date in the future, or to have it run at certain intervals. For example, perhaps you want to generate the Assignment Report on the last Friday of every month. You can also automatically upload an executed, scheduled reports to the Upload folder or any child folder of the Upload folder of your SFTP server. This enables you to streamline any post-processing workflows you might have in place. To schedule a report, do the following. On the Control Panel:

Click on the Reports menu to expand it.
Click BI Reporting.
Click in the Action column for the report. A menu opens.

Select Schedule. The report opens in schedule mode.

The number of tabs available depends on the type of report you selected. Reports that do not have options for Users will not have a Users tab.

BI Reporting Standard Report results only show mapped Users. Regardless of what Users you select on a report, you will only see those Users mapped to the items in the results.

Select the Statuses of the Users you want returned in the report:

Approved
Denied
Pending
Removed

Select any additional individual Users and Groups you want to include in the report.
Indicate whether you want to only show Users with a certain status for those additional Groups you are including in the report.
Select the Parameters tab.
The Parameters tab contains parameters specific to each report. The instructions for the report parameters are detailed in the specific online help topics for each report.
Select the Fields tab.

The Fields tab allows you to select from the fields that are available on the report you selected. When you first visit this page for any report, the Use the default fields for the report check box is checked by default and the Fields and Results Sort Order selections are dimmed (gray). The fields in the list boxes on the right side of the page list the pre-selected (default) fields and sort orders for the report. You can build the report as is, or you can clear the Use the default fields for the report check box to select the fields and sort order that suit your needs. Once you make changes, the report is considered a custom report.

To make your own selections, clear the Use the default fields for the report check box. The fields and sort orders become active and you can make changes.

The fields in the left list boxes are other fields available for this report.
Move fields from the left list boxes to the right list boxes to include them in the output. Any custom fields you have created in the LearnCenter that appear as selections in the list boxes can be included in the report.
Use the “Move Up” or “Move Down” buttons next to the right list box to select the order of their column position in the output. (The top field is the first column, the second field is the second column, and so on.)

Type a Custom Report Name to save your selections for later use.
Select the Output tab.

Use the Output tab to indicate in what format you would like the report to be generated.

PDF
RTF
XLS
HTML
CSV
Interactive HMTL (You can manipulate this report)

Best Practice Tip: If you plan to use all fields in your report output, particularly with the reports that have a lot of available fields, it is recommended that you select XLS as the output, because you will be able to manipulate the size and spacing of the columns using Microsoft® Excel. You cannot manipulate or edit the outputs results for PDF, RTF, HTML files or CSV. With Interactive HTML, you can manipulate sorting and sizing in a similar manner as XLS files.

The BI Reporting .CSV file format does not use any custom layout files. It will always return the columns selected for the report.

As a Beta release, BI Reporting reports are limited to 65000 records. However, your chosen output format might have additional limitations. For example, if you include too many fields or rows of data in your output, and you reach the Microsoft® Excel spreadsheet data limit, your report data will be truncated. When generating PDF output, BI Reporting does not limit the size of the output file. However, when the size of the file approaches 2 GB, Adobe® Acrobat® Reader may no longer be able to open or handle the file. This is an Adobe limitation. When selecting the Interactive output, the complete data set that is passed to the layout should be limited to several thousand rows to achieve a responsive report.

Indicate whether you want to be notified by email when the report has completed. Indicate whether you want a link to the report included in the email.

No report attachments will be emailed to you. You will have access to your report online for up to 90 days. This eliminates the possibility you might not receive an email with a report attachment due to file size restrictions or security rules that are put in place for your network or email system.

All Users will be forced to log in to LearnCenter if you click a hyperlink to a report in an email. This ensures that only authorized Users of your LearnCenter can view reports. The LearnCenter SSO feature will work with this authentication. This security is enabled for all LearnCenters.This security can be disabled. Contact Customer Support through My Oracle Support, and open an SR requesting this functionality to be disabled.

Click the Copy to SFTP folder check box to indicate that you want to automatically upload an executed, scheduled report to the Upload folder or any child folder of the Upload folder of your SFTP server. You can select the appropriate folder from the drop-down list.

Use of this field enables you to streamline additional post-processing workflows you might have in place. In addition, if you use this with the CSV output, saving to an SFTP folder helps to automate report data into third party integrations or operations.Interactive and HTML outputs are not available for uploading to the SFTP server.

Important: If someone deletes the SFTP folder, the report is still accessible from the Last Run link on the BI Reporting main page and it can still be run, but it will not be copied to the SFTP folder since it no longer exists.

Select the Schedule tab.Use this tab to set up the automatic scheduling of the report generation.

Indicate whether the report has a Recurrence pattern by clicking either This Report has recurrence or This Report does not have recurrence.
If you selected This Report has recurrence, select one of the following intervals for the report recurrence:

Daily - to have the report recur on a daily basis. You can set the recurrence to every day, or the x day of the month and every x days after. For example, on the first day of the month and every 3 days after that.
Weekly - to have the report recur on a weekly basis. (Default)
Monthly - to have the report recur on a monthly basis.
Yearly - to have the report recur on a yearly basis.

The remaining fields in this section vary depending on which option you selected.

You cannot schedule report recurrences for dates in the past. A warning message will display to alert you if you have done this. The End By date must be at least 1 day greater than the current date.

If you selected Daily, do one of the following:

Enter the number representing the day of the month on which you want the recurrence to begin. For example, typing "2" indicates that you want the initial report to be run on the second day of the month.
Enter the number of days after the initial run that you want the report to generate again. For example, typing "3" means you want the report to run every 3 days after the initial run.

Note that the default for both fields is 1, which means that you want the report will run every day starting on the first day of the month. If you want this report to run on the 15th day of the month and every 5 days after that, you would enter "15" and "5" in these two boxes, respectively.

If you selected Weekly , you can then select which days of the week you want the reports to generate.

If you selected Monthly, you can also indicate the Day of the month you want the report to run. (The default is 1 to indicate the first day of the month.) You can also have it run every 1 Months (default) or every x number of months after the first run. For example, if you want to run this report on Day 1 of every 3 Months, you would enter 1 and 3 in the boxes, respectively.

If you select Yearly, you can indicate the month and day on which you want the report to run.

When you have finished making selections, click Show Schedule to display a schedule of when the report will run, based on your selections. Use this information to determine if you need to edit your selections, and get the recurrence pattern the way you want.

Click the Notify me[x] days before report will expire if you want to receive a Communication Message to alert you when the scheduled recurrence is expiring soon. The number of days before the report expires depends on the recurrence pattern you selected.

For a Daily pattern you can be notified 5 days before.
For a Weekly pattern you can be notified 15 days before.
For a Monthly pattern you can be notified 60 days before.
For a Yearly pattern you can be notified 90 days before.

Indicate who should get the scheduled report. Click Add and select the Users you want to receive the report. You can come back to this page at any time and change the recipient list. You can clear the Send the Report to Me check box to prevent the report from being emailed to you, but you will always receive an email informing you if the report fails since you created the schedule.
Click Save.